sqlx4k-postgres/io.github.smyrgeorge.sqlx4k.postgres/[jvm]PostgreSQL/Tx

Tx

class Tx(connection: Connection) : Transaction

Represents a transactional context for executing SQL operations with commit and rollback capabilities.

This class implements the Transaction interface and ensures thread safety through the use of a Mutex. It provides methods to manage the lifecycle of a transaction, execute SQL operations, and retrieve result sets.

Parameters

connection

The database connection associated with this transaction.

Constructors

constructor(connection: Connection)

Initializes the transaction with a given database connection.

Properties

status

open override val status: Transaction.Status

Functions

commit

open suspend override fun commit(): Result<Unit>

execute

open suspend override fun execute(statement: Statement): Result<Long>

open suspend override fun execute(sql: String): Result<Long>

fetchAll

open suspend fun <T> fetchAll(sql: String, rowMapper: RowMapper<T>): Result<List<T>>

open suspend override fun fetchAll(statement: Statement): Result<ResultSet>

open suspend override fun fetchAll(sql: String): Result<ResultSet>

open suspend override fun <T> fetchAll(statement: Statement, rowMapper: RowMapper<T>): Result<List<T>>

isOpenOrError

open fun isOpenOrError()

rollback

open suspend override fun rollback(): Result<Unit>